You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
ASPERITAS STUARTIAE |
8.00 | |
CYMATIUM LABIOSUM |
6.00 | |
POLLIA SUBCOSTATA |
8.00 | |
ERGALATAX MARGARITICOLA |
4.00 | |
KIOCONUS cf. EMPRESSAE |
20.00 | |
MITRA PAPALIS |
12.00 | |
EUVOLA CHAZALIEI |
20.00 | |
XESTA BANGGAIENSIS |
8.00 | |
PINCTADA cf. MACULATA |
6.00 | |
LAMBIS LAMBIS |
25.00 | |
PATELLOIDA SACCHARINA LANX |
3.00 | |
TEREBRA FORTUNEI |
6.00 | |
CANCELLARIA LYRATA |
12.00 | |
TURBO FORTISPIRALIS |
5.00 | |
CONUS SCOTTJORDANI |
30.00 | |
HARPA HARPA |
10.00 | |
ZIERLIANA OLEACEA |
6.00 | |
SEMICASSIS CANALICULATA |
8.00 | |
TEGULA FASCIATA |
4.00 | |
CIRCULUS SPECIES |
3.00 | |
JUJUBINUS ESCONDIDUS |
5.00 | |
CONUS AMMIRALIS |
6.00 | |
SPONDYLUS OCCIDENS JAMARCI |
15.00 | |
PARDALINA TYLERAE |
3.00 | |
LATIAXIS MAWAE |
30.00 | |
CERITHIUM GUINAICUM |
8.00 | |
TYPHIS MONTFORTI |
25.00 | |
MORULA MUSIVA |
6.00 | |
TEREBRA FUNICULATA |
3.00 | |
STROMBUS AURISDIANAE |
12.00 | |
CANCELLARIA INDENTATA |
12.00 | |
CANCILLA GRANATINA |
4.00 | |
GRANATA IMBRICATA |
12.00 | |
CYCLODONTINA SECTILABRIS |
4.00 | |
HALIOTIS SEMIPLICATA |
8.00 | |
COMITAS PEELAE |
40.00 | |
GYRINEUM GYRINUM |
6.00 | |
CYPRAEA MARTINI SUPERSTES |
60.00 | |
CONUS TORNATUS |
12.00 | |
Total: | 475.00 |